package com.example.bilibili.mapper;

import com.example.bilibili.domain.Guanzhu;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.bilibili.domain.guanzhuvo;
import com.example.bilibili.domain.uservo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

/**
* @author 86158
* @description 针对表【guanzhu】的数据库操作Mapper
* @createDate 2022-09-26 08:51:10
* @Entity com.example.bilibili.domain.Guanzhu
*/
@Component
public interface GuanzhuMapper extends BaseMapper<Guanzhu> {
    @Select("SELECT useravatar, userauthor, userautograph,bili_user.userId FROM bili_user left join guanzhu on bili_user.userId=guanzhu.uploaderId where guanzhu.userId=#{userid} ")
    List<guanzhuvo> getguanzhu(Long userid);
}




